package com.ruoyi.huanghefd.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.ruoyi.huanghefd.domain.AttachsheetOs;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;

/**
 * @Entity com.ruoyi.huanghefd.domain.AttachsheetOs
 */
@Mapper
public interface AttachsheetOsMapper extends BaseMapper<AttachsheetOs> {
    /**
     * @param attachsheetOs
     * @return int
     * @Author gnplum
     * @Description //新增 作业安全风险控制卡
     * @Date 16:45 2023/11/13
     **/
    int insertAll(AttachsheetOs attachsheetOs);

    /**
     * @param asCode
     * @return int
     * @Author gnplum
     * @Description //删除 作业安全风险控制卡
     * @Date 16:47 2023/11/13
     **/
    int delByAsCode(@Param("asCode") String asCode);

    /**
     * @param attachsheetOs
     * @return int
     * @Author gnplum
     * @Description //修改 作业安全风险控制卡
     * @Date 16:46 2023/11/13
     **/
    int updateByAsId(AttachsheetOs attachsheetOs);

    /**
     * @param asCode
     * @param asState
     * @param userId
     * @param mailType
     * @return java.util.List<com.ruoyi.huanghefd.domain.AttachsheetOs>
     * @Author gnplum
     * @Description //查询 作业安全风险控制卡
     * @Date 16:50 2023/11/13
     **/
    List<AttachsheetOs> queryAttachsheetOsList(@Param("asCode") String asCode, @Param("asState") String asState, @Param("userId") String userId, @Param("mailType") String mailType);

    /**
     * @param asCode
     * @param asState
     * @param userId
     * @param mailType
     * @param startIndex
     * @param pageSize
     * @return java.util.List<com.ruoyi.huanghefd.domain.AttachsheetOs>
     * @Author gnplum
     * @Description //查询 作业安全风险控制卡 分页
     * @Date 16:15 2024/1/3
     **/
    List<AttachsheetOs> queryAttachsheetOsListByPage(@Param("asCode") String asCode, @Param("asState") String asState, @Param("userId") String userId, @Param("mailType") String mailType, @Param("startIndex") int startIndex, @Param("pageSize") int pageSize);

    /**
     * @return int
     * @Author gnplum
     * @Description //作业安全风险控制卡获取编号
     * @Date 16:34 2023/11/6
     **/
    int getAsCodeNum(@Param("PJLX") String PJLX);

    /**
     * @param asCode
     * @param asState
     * @param userId
     * @param mailType
     * @return int
     * @Author gnplum
     * @Description //作业安全风险控制卡 数量
     * @Date 16:11 2024/1/3
     **/
    int getAttachsheetOsNum(@Param("asCode") String asCode, @Param("asState") String asState, @Param("userId") String userId, @Param("mailType") String mailType);

}




